import pymysql

db = pymysql.connect(host='localhost',user='root',password='926979',port=3306,database='test')

cursor = db.cursor()

sql = "SELECT *FROM EMPLOYEE WHERE INCOME >%d"%(1000)

try:
    cursor.execute(sql)
    results = cursor.fetchall()

    for row in results:
        fname = row[1]
        lname = row[2]
        age = row[3]
        sex = row[4]
        income = row[5]
        print("name = %s %s ,age = %s, sex = %s,income = %s"%(fname,lname,age,sex,income))

except:
    import traceback

    traceback.print_exc()
    print("Error:unable to fetch data")

db.close()